Description: The Required Minimum Distribution [RMD] working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This is Appendix H spreadsheet for persistency bonus calculations for this research project. Please see teh SOA website research section for the complete report and excel spreadsheets for other appendices.

Description: Authored by a MIB Solutions team of Tom Rhodes, Stuart Klugman, Marianne Purushotham and Stacy Gill, the report summarizes the results of a study on the application and adoption of credibility theory within the life insurance and annuity industry. This excel spreadsheet is a numerical example relating to the application of Credibility for lapses. Please see the SOA website research section for the complete research report on Credibility Theory Practices.

Description: The Required Minimum Distribution RMD working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferrred annuity contracts. This is Appendix B Example 2 spreadsheet for GMDB for this research project. Please see the SOA website research section for the full report and excel spreadsheet for the other appendices.

Description: 2011 SOA IFRS Seminar, Hong Kong. This is an Excel spreadsheet associated with Session 15 - 'Cash Flows Workshop' at the 2011 SOA IFRS Seminar held in Hong Kong. This spreadsheet facilitated the sessions objective of calculating the beginning liability values for the Statement of Financial Position.

Description: The Individual Life Experience Committee has completed their latest report on intercompany mortality experience by amount of insurance under standard individually underwritten issues. This study includes policy years 2002–04. Also included is information on the Milliman extension to the 1975–80 Basic Tables and an Excel spreadsheet with the values used in the above. This is that Excel Spreadsheet for the Milliman extension to the 1975-80 Basic Tables.

Description: 2011 SOA International Financial Reporting for Insurers Seminar, Hong Kong. This is a spreadsheet associated with Session 26 – 'Presentation Workshop' held at the 2011 SOA International Financial Reporting for Insurers Seminar in Hong Kong. This spreadsheet facilitated the objectives of the workshop which focused on building the statement of comprehensive income using the exposure draft approach.

Description: A recap and highlights of the activities and accomplishments of the SOA’s professional interest sections.

Description: This Excel spreadsheet will perform examples of the tax arbitrage described in Section 4 of the 'Pension Actuary's Guide to Financial Economics' and should only be used in conjunction with the guide.

Description: Long Term Care Think Tank: Exploring the possibilities for helping the American public manage the financial burden of long term care. This report shares the output of a 1.5 day structured brainstorming session involving some of the LTC industry’s preeminent thought leaders. Ideas presented here are intended to help transform the delivery, accessibility, and financing of long term care.